SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404920 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404920 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374305,756481,759317,940620,436556,849551,831001,228451,124836,895032,203055,561747,869062,1005454,28847,706639,141771,214762,190217,416914,72334,27348,972328,592133,930071,993371,122565,966996,13990,678280,442553,46135,830736,108581,46921,829713,736122,60309,69762,715075,631404,526178,4656,731879,749420,923526,601872,422279,692634,222720,449327,710429,94608,636579,280541,166690,41695,838992,53580,993364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004772s ]