SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811018 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811018 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580470,769987,380995,37559,112295,254357,531908,209460,845308,572521,91551,282762,1043393,406611,382038,31724,1044558,349884,764130,227031,787179,384502,232961,907616,105492,470835,1039673,161254,137139,380619,72326,388107,248416,780280,890294,35941,363076,1001824,325253,932784,377591,603033,1033000,915097,952457,454954,165610,90677,639995,609647,993708,315343,840327,651941,258584,498003,567541,928546,87998,327255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]