SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762004 LIMIT 1 [ RunTime:0.002529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762004 [ RunTime:0.002722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100481,78635,749506,658985,770980,881370,1024722,9448,728074,691042,595383,262877,463374,691649,917220,547410,788796,898777,897735,1016010,824375,475546,781267,627737,564155,98536,760904,173343,37006,359848,586225,705633,938720,70032,704823,659882,200679,813748,304968,954359,464415,390497,796985,737439,85860,494757,243192,865010,771427,25827,632791,327370,759354,624616,330352,777795,77478,440907,518385,827387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]