SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100406 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100406 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174183,339686,858490,719854,242529,877455,960254,557129,641866,66086,534340,584100,637026,493433,136614,845983,353719,86749,498249,175706,933102,34834,276800,240735,817857,504961,336308,331637,970458,68968,588731,630899,213472,291247,126964,187666,85471,597836,768191,1036569,625929,535457,839831,355879,516044,254408,158347,79843,330133,542247,804242,791054,778417,1002154,717702,1004003,752688,450928,1013635,335663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]