SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522953 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522953 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957379,881796,428129,738406,71880,515284,135959,785692,756006,734989,995943,481795,848469,44648,623020,64019,965427,384559,278477,478920,767819,482522,509703,437876,641935,739845,619008,693572,552431,947200,858476,259827,298252,743318,347549,4738,431456,33066,591205,203600,96628,553450,652377,389952,1029318,782306,782363,630756,234255,585929,593240,368278,851142,569220,808037,977254,846360,249160,1048916,313453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]