SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415420 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415420 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5770,999866,426905,731934,346789,803760,420780,298616,295710,97940,621758,790717,241983,132354,855385,733965,1012783,273241,19811,779772,487715,185462,917262,769454,201004,937591,167123,993626,85798,620825,895445,208299,977294,730947,38429,560818,197253,1015675,159019,896311,445780,937327,221808,694457,665527,561255,69209,570442,861679,749541,280728,901702,663718,157437,716240,383232,825152,676270,475245,828115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001520s ]