SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336594 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336594 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043313,218073,19908,393033,465408,441299,114199,728359,991868,567534,778851,935590,185884,1040411,30102,370773,137982,419403,120018,600782,429949,355599,519718,446756,528869,535807,346923,268741,801296,337978,172697,338599,869240,414211,1040935,371460,295467,23265,668276,270164,30576,304272,638889,693776,391381,1031184,827760,196699,1046143,581962,573997,813883,177858,692414,268526,167337,685847,371325,723525,373870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]