SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40940 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40940 [ RunTime:0.003600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215209,474148,67299,620952,262141,734057,1006571,1010155,428502,419216,318413,728869,1032546,572621,114763,87591,12878,531466,81718,196033,912833,261653,394401,232168,940756,779905,737507,947293,290665,514681,774204,483148,676242,335808,201890,580247,52520,968575,369741,325960,810340,752205,44508,71152,987385,353779,1014301,860276,915334,334531,318226,495512,934097,408822,908481,890459,227691,810016,940803,706714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]