SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122801 LIMIT 1 [ RunTime:0.000635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122801 [ RunTime:0.004610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806012,560728,459820,533488,301051,18234,52404,552488,840847,248707,235129,720160,242430,88098,201678,972056,767562,1035870,344743,679748,479891,907333,139485,921528,945923,295431,310076,14891,399281,965767,785399,109800,116479,211229,448465,871093,382420,217481,286601,1041232,368755,904416,845757,182277,164364,895650,1046204,1013308,1019261,100471,180707,541095,433368,525383,663734,76657,931664,1014088,821375,336475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001599s ]