SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368618 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368618 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215543,334212,520265,160963,257866,315406,131417,798281,273417,1037455,821497,594133,949720,901080,514682,971673,1023249,764210,576624,560198,986071,266448,460062,651878,860064,574665,1028840,399984,895433,574667,503809,629624,929272,128045,101532,500717,74942,946705,244905,364396,778637,555404,695418,780861,124745,722408,169125,895757,587801,725452,28999,108587,440957,358610,455727,112973,513257,1034225,1037662,923851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]