SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004307 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004307 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033089,607908,350067,478446,870958,148382,649671,693318,786015,157643,410850,4912,947968,338421,639445,484903,903233,642240,585686,494510,415286,1017958,999027,1044492,243969,317643,140953,44134,110984,342401,318405,129416,5256,855503,470770,786357,637562,743068,73316,681653,897694,936858,158189,794204,694334,130020,421797,975458,762860,906586,421596,1011624,213929,666708,15319,514150,750831,1011350,905777,346793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]