SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001879s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920818 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920818 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268374,925274,950985,372140,374117,347313,646463,187176,23766,158731,706070,945771,413055,232685,268091,294718,841997,362914,712444,589446,411044,272038,565525,822138,991355,654348,896859,644476,959575,255067,487576,410872,235752,796578,868981,912690,168645,752242,468642,489390,409266,440253,72912,550294,179885,307895,21434,939138,689368,22768,712080,947026,782488,448265,309873,42882,437150,745686,13824,118323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]