SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012429 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012429 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513834,41262,882602,758045,982309,907349,811629,211469,863969,958901,555309,751605,22861,33952,501489,350824,98721,686992,737541,190855,700659,918470,642700,765436,857315,986137,389415,414343,74521,712075,768540,351185,379316,991211,844713,554724,625069,426078,107620,204977,32464,262459,114924,1011277,20243,584713,720579,761018,254133,191683,207525,765385,218660,814666,30991,325569,548994,19386,331824,513394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]