SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031559 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031559 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727743,820966,578381,112080,475290,369739,936908,325906,150427,65710,656300,109597,816341,969425,551304,358021,8095,1013002,984708,156690,848087,658808,174657,331205,383551,30016,334201,716294,538833,120797,440008,144278,728342,78947,1014154,370906,31829,611500,341791,800304,477199,311840,83228,212475,237408,102251,681517,1021719,53445,71406,300133,130498,189588,867161,791562,81235,1008797,242296,437662,535033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]