SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426030 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426030 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627241,309676,905424,148488,391510,153281,419031,666521,74555,837250,272645,474867,541405,709998,841059,552129,214654,753133,846721,517711,985458,882611,929264,720985,628703,424457,710070,150926,315318,504768,726854,300346,257941,1011598,232182,641095,395463,860670,743580,428106,358142,741215,79203,37662,247769,207464,530062,396104,131962,956011,772441,625614,956521,324853,143877,1020709,898412,692267,884850,291707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001081s ]