SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293309 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293309 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920920,260964,770073,802517,769406,351988,921291,309616,895240,662802,671001,924835,1017630,149805,248847,944975,185109,798075,936636,900642,324053,763380,256080,79541,891224,390802,527621,755850,754249,757970,308411,1001039,370526,530868,1004310,402262,549220,476305,565260,286692,824177,637264,713742,307540,952630,441236,141066,868702,607947,853746,285268,651515,857730,650481,920064,976631,426011,705622,320117,365497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]