SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547065 LIMIT 1 [ RunTime:0.000832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547065 [ RunTime:0.005566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295557,13438,733212,763642,893662,692592,494866,512183,431709,834192,615106,439475,842434,426106,713536,536212,722974,774393,486446,577992,732013,588359,813811,778179,572650,677428,758530,713876,639801,439562,162257,324005,284572,419398,1016461,92517,667510,591210,819647,703167,207647,825794,201723,1022476,291218,209190,998925,285461,1038789,732147,935016,499553,353437,1031168,559365,453910,27353,840227,360490,1019992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000986s ]