SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684522 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684522 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032671,919588,988309,253611,792936,342768,930280,61783,425181,966596,17741,908725,994450,931245,469566,153931,289085,62517,589815,488250,111168,419074,89693,591291,295382,857567,78141,682841,500960,682072,466978,600488,627970,400046,577926,31498,901616,822964,376373,39901,831113,852771,728446,579484,876593,887000,133630,607719,726484,147911,682392,226228,975873,178450,418328,296970,490120,587184,114511,768675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001592s ]