SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342322 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342322 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413016,702100,163857,830048,849408,812162,1040273,775565,1016587,683176,164857,538510,703542,576279,374424,551776,52311,1010387,823029,1006618,608647,813969,481151,494986,211877,455080,873992,305209,356536,539058,388795,210542,932340,694786,181927,74472,691328,323617,286581,613825,320967,522012,823438,1033948,476327,491066,983908,533685,599252,216432,250149,454823,740027,407278,953301,353231,903751,62539,26299,371183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]