SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001380 LIMIT 1 [ RunTime:0.000918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001380 [ RunTime:0.003142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87107,647034,160571,202856,787444,702465,669867,584964,949891,58478,370551,538676,768008,909080,212394,567110,889834,217250,359805,33001,598303,154173,1007429,224774,418273,725431,192416,215309,189387,119901,721468,825502,627463,791218,202046,3202,873522,731955,553622,9521,930131,1040684,994167,378917,214886,824805,928317,358120,312769,502936,287176,301673,157826,845923,881200,741330,793433,566676,514814,850792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005504s ]