SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504015 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504015 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461660,360402,230935,666125,497686,191694,932925,121848,90400,482220,294833,332291,393872,172066,991421,17020,908351,18665,976980,872547,97078,507635,700941,936579,353959,1170,917061,854735,836972,948090,180933,402543,1042196,275973,156235,797196,724180,717734,553844,151302,459088,584849,547551,1027343,803820,480629,752205,955627,409650,748282,71643,1007589,326973,460616,600750,735532,847488,155535,492824,94601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000840s ]