SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567043 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567043 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003638,299337,437790,966805,429320,108874,946376,502025,371243,85402,566136,499123,790839,738570,729374,658157,15862,739103,717931,35535,99057,849090,200035,73193,520853,914319,109398,204356,639919,675912,1002810,6476,364381,204068,110227,830645,815182,203023,855426,17431,1003049,489235,814268,1039797,999496,450962,74638,334864,891406,2108,557508,246652,649532,682033,638905,268761,407540,663398,374576,404318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]