SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104975 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104975 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7542,728554,407077,890115,945404,465058,182010,998002,880075,404066,55751,438651,466295,677710,338846,209443,883818,336911,131980,786124,845410,767816,626782,315735,250117,320543,638159,403607,465409,251339,1012913,57242,143895,222800,456815,813687,83491,222224,977518,354386,60438,505296,981964,547124,665562,534192,377513,947277,65691,906313,153160,510782,379778,363606,929051,715777,735915,981644,446414,690996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]