SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549871 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549871 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3233,1014086,765811,1036842,850750,565882,509381,336229,784857,965919,408435,672468,709121,298693,737074,251267,711857,172048,991358,611920,544323,98781,582545,140985,54712,801875,130185,245793,7466,567427,530649,126830,311573,988185,647599,517039,680542,618229,732733,872949,745332,757863,599381,457561,768387,254180,580333,861813,385834,343116,192542,754634,18559,135843,532760,910325,32280,554833,375305,419471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]