SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681943 LIMIT 1 [ RunTime:0.002197s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681943 [ RunTime:0.007328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538595,185792,426917,967910,1019849,571795,713399,252689,471490,658869,292366,799102,497741,253492,561264,665075,212714,9183,103843,802747,336670,720204,187568,519599,360328,706562,471284,363276,323007,984124,199990,1016946,927941,722524,913518,22126,718570,90573,592813,959631,572699,836854,630784,368991,377240,485053,889864,951760,735813,737600,186871,702198,954784,197981,334870,465912,212986,234606,522527,835998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006940s ]