SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280860 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280860 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444171,610328,330506,538547,292567,703483,212649,945843,943350,711740,734040,1045732,500618,664434,1039504,680110,774621,383797,293190,107664,369776,386325,316077,192891,612170,1040602,913318,71128,616726,736590,603992,569970,649272,374279,713925,1037072,319809,476943,379398,861111,54209,840525,1044950,841413,411640,762855,266854,777211,1034421,9355,363061,234827,828793,620238,57352,330991,652612,25155,790493,58718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]