SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345902 LIMIT 1 [ RunTime:0.000847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345902 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733803,152348,304527,157969,810245,74298,142802,1006205,565117,369642,197914,462280,610893,992723,341110,452237,113152,781401,917644,365754,742895,593552,570961,1043792,591672,534927,46127,110643,383081,488730,893590,1030412,480572,3101,404391,235035,807539,695025,734152,889084,716154,1011949,338452,134704,780983,257501,223459,182722,862541,311627,386571,60613,1012764,777572,870308,654183,698823,1024780,782875,196504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]