SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458331 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458331 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010449,790424,72390,121891,720952,130067,151504,909229,241793,728782,346989,468089,807667,778434,1018429,494220,1043581,823945,495315,658255,813268,182890,1010012,737856,334755,705241,673250,1013250,348954,371660,296660,974828,144168,65733,423881,543099,36663,521163,280533,710435,751481,270663,501525,188140,791113,103382,194976,29269,591491,163196,60818,72291,178864,328098,291096,331765,72493,549052,756113,231707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]