SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310038 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310038 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043970,367360,676517,884457,851149,837741,581574,56135,932193,770109,648157,645598,979292,65234,500142,877186,481743,310220,628668,939219,163160,813556,306326,192305,717777,32953,399106,227521,798837,993208,542387,802547,504189,360541,415476,247539,739273,526020,103852,1044992,337847,341554,847502,638602,165159,762239,335025,559151,400812,810140,379305,98875,1009540,23804,972880,697793,775180,330647,591845,181684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]