SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 838601 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 838601 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828126,557703,22112,256073,924479,421060,990749,102842,448333,263423,422318,866248,465210,229008,184656,231587,389787,361883,96726,201479,81013,924801,199480,299483,1117,258931,612729,865594,128034,542453,736590,1002458,187510,603731,315324,100840,160783,985001,304493,68300,808573,722783,677380,197820,719575,289649,180283,315441,301321,215873,569460,759965,420182,39397,313974,354518,579201,478545,591831,768757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 838601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 838601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]