SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543908 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543908 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932657,607247,34674,790681,287577,983870,435755,673207,10734,44873,762173,731905,333002,97193,1007849,246555,215112,66167,906361,513787,317122,299221,784417,611308,59099,519150,976998,471520,733445,578554,420121,543057,641494,424161,331226,684305,966515,379363,144228,365912,262666,817037,176889,695333,700408,479842,1046554,707480,702556,61388,192583,618313,866562,387375,1048612,322678,712382,689382,430060,898408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002064s ]