SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047676 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047676 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643485,521206,1007419,631375,24048,985315,31341,201718,864314,706518,108148,76379,495483,547415,981562,674749,300664,267032,107228,723010,106108,214044,860850,706808,719686,161980,188907,90558,131611,75820,723180,595263,82107,31135,266919,745024,97381,270188,504905,117524,473528,951627,233526,788998,755156,441715,427188,28759,643249,432066,523659,631500,491877,501334,783142,491477,369035,1023680,781140,1004915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]