SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405530 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405530 [ RunTime:0.002330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588921,909445,977041,535667,981332,724235,297455,595750,215284,979146,85771,30119,348144,190870,856479,483499,507948,331132,38200,656246,281702,311035,405774,590842,406362,507538,294498,737618,432141,1018736,697954,850145,240463,361339,352297,716917,757590,204568,1003822,971923,556005,925035,953528,442068,952070,319805,283699,121983,21090,759294,75761,905701,286329,172592,425488,737259,547899,378504,261216,1009457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]