SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541941 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541941 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635621,28539,978174,876637,54004,303977,452178,538374,511325,144989,909155,49878,231328,498579,828507,892581,314283,1018443,971586,510072,522293,792166,617532,763687,348237,120652,925521,586161,137167,98130,594953,452111,811878,157354,722058,161477,1030560,28927,910253,919024,684293,580913,220254,887231,591344,535549,306662,969083,763996,100251,419378,112623,431426,94749,890144,383658,420753,653694,827525,982715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]