SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381718 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381718 [ RunTime:0.003216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567302,643686,933035,719868,64127,79003,872058,6721,449971,121771,535666,1012898,273298,351751,581211,52680,453198,1034581,315778,432807,557673,494312,249999,1011883,1015275,955934,114669,397109,4689,368057,989675,223759,804489,950785,80637,698297,832168,165000,891592,863769,415198,273981,389633,53,816203,922557,443967,451174,840558,305712,584544,910618,398605,718676,823575,978910,728554,532008,891911,325906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001638s ]