SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105079 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105079 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711538,1025772,389856,53852,693686,1023123,992722,722547,987485,626891,114693,394767,941967,716509,561718,169797,538529,579825,200449,287108,122925,265229,678702,515023,952924,8367,895724,99649,748277,557668,970692,244530,582109,660863,38119,993230,734999,522792,474261,942449,441174,572037,199089,330439,969300,298448,854995,1036038,339685,1044777,229836,201633,40136,114208,140239,768596,670417,886005,710004,83067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]