SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289728 LIMIT 1 [ RunTime:0.001184s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289728 [ RunTime:0.004289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114958,697246,305774,380723,983417,580503,501882,771385,1005291,1030499,625773,152508,11292,403206,809676,962333,129819,346061,902911,226068,1032596,864816,516848,798349,608213,837624,13607,75625,364296,673785,640163,121252,544310,1037829,282206,320363,744380,592417,129817,526209,606397,614799,984020,691347,196151,734173,664192,96829,857741,741896,917035,169065,45829,399411,489571,479569,816404,255608,2843,52982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]