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` = 149611 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149611 [ RunTime:0.003369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46648,544326,641358,501565,4048,550831,246689,15216,1042782,760780,170500,977578,303224,415933,261581,375226,106055,794767,10923,222010,603164,288640,710447,332026,82018,102555,153057,780981,100248,611853,829283,145280,263353,889303,956012,253542,627930,658062,739933,146188,41679,974327,844688,241695,745423,402090,303587,266877,3705,721813,953038,897805,68062,615158,564986,299323,937613,767142,490261,516674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]