SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486937 LIMIT 1 [ RunTime:0.001210s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486937 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414163,206057,596105,83494,561568,808981,1009035,976121,80834,741917,536320,516459,500774,941231,205600,301034,511988,845204,611607,207512,626960,575873,23421,700621,361438,445916,245100,727741,794392,734289,482018,330209,758299,369852,826678,50814,652466,428707,714231,133757,699294,164027,267050,436945,534922,968368,984231,42750,332263,452116,362689,466931,1045235,587399,177570,572245,51844,1047438,773285,449821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]