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` = 101535 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101535 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41233,449067,998734,599140,192071,822619,812960,7131,986255,226338,201628,393873,198675,777723,58330,531004,299826,684640,166370,676521,518112,240186,530549,768259,235731,822273,931639,277635,24994,749880,973185,819670,970485,273426,735551,568903,201096,46236,927680,823039,1016388,487217,621672,1047207,604100,146731,576106,24117,526220,886505,656310,522515,889043,133707,718419,308175,435568,785026,846346,225325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]