SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103131 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103131 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10009,460935,733477,690248,80335,488480,913118,528943,404255,949836,369265,122503,326263,540037,14822,744118,49511,1007420,566415,781455,112227,1013731,799846,494635,506940,955515,448410,1010018,954659,47879,103602,906405,666432,815339,373060,974316,443986,782842,258364,696701,536253,475822,978424,852849,656751,536658,873199,308015,1006019,525767,1025705,481649,233098,544509,532142,68328,168553,907963,362177,744195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]