SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443540 LIMIT 1 [ RunTime:0.005618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443540 [ RunTime:0.006775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718549,357832,457072,483309,68160,1046725,382018,769386,767893,593104,10188,245005,362642,136080,840257,384026,125422,707684,464859,12760,628682,331960,801861,201339,287532,932884,400078,540474,624135,643344,74933,825730,607891,954886,1032422,975974,14091,685825,674712,773963,450816,772450,368416,685612,501333,988463,181105,378071,154395,825630,271638,534390,123624,933888,751492,422104,763447,764861,251065,920979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]