SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010942 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010942 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739269,845038,870127,751718,63122,164223,692830,940735,349532,843922,995241,747414,481247,86988,649772,478906,886098,45064,1021889,895333,286730,961190,358321,950169,338516,507082,40000,345005,24697,890723,331111,409377,457126,43455,3249,1047665,556588,607154,111108,775766,272204,505168,688345,223259,31367,797201,745226,561856,829243,876454,580572,823403,442541,517230,722332,504650,97001,718149,924126,534097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]