SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482998 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482998 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290257,1041173,16935,980651,637315,587229,766999,348055,502089,440513,582501,31214,709860,4073,845502,690590,16418,538107,320326,820713,779461,86201,725233,860335,957946,613693,427298,355410,101351,401624,994155,224259,994710,522629,758494,456444,430264,582128,684766,787077,372150,844062,738283,75202,887822,60227,493774,644945,603644,842427,302623,146576,1010047,848214,910501,830103,416445,614900,938328,821489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]