SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601501 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601501 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835690,250029,1012266,642632,832635,930910,32882,898507,747237,165407,639672,726423,835241,223949,122390,920235,24526,642213,194742,587956,569869,571569,405005,282392,854811,873781,94855,210958,636616,396398,427095,285767,866097,832164,406354,396784,625836,455342,749099,800739,852585,482666,319520,554381,418199,974259,476622,334190,980293,398014,375770,56061,138218,566339,7481,774280,375643,198317,674521,717816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]