SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250418 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250418 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039717,304980,501143,556060,886533,244616,826615,701329,858215,798436,224890,414368,413782,195220,541913,614175,758289,795596,753510,54958,848815,862917,41972,954986,423521,980907,36934,681067,120199,415349,215188,331351,131316,337858,875162,644626,631769,994187,194905,967468,187266,212813,658658,364833,163228,846825,165213,570130,952655,995060,1012324,193904,623323,274045,667585,1006481,711084,340249,562506,102794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]