SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101311 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101311 [ RunTime:0.003338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15546,676862,927023,898319,552697,512150,168745,502617,465380,36014,525537,14136,214888,521470,262970,425036,315573,953434,453412,870631,427016,39322,36928,964719,282540,63855,949515,517275,974310,251760,351367,1030398,13472,901642,186014,568777,792794,302922,249704,950282,1017417,1014138,390473,289360,164462,593373,445580,221317,57482,67853,398426,454451,278603,654750,331258,236624,46010,818631,307611,738896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]