SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413846 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413846 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518138,171161,883242,329745,841283,924512,328950,310750,371078,484394,871759,406109,335529,430738,281285,169065,271370,487646,796225,209571,238940,355005,683491,995440,369852,1023033,566365,65587,9019,470624,635517,296948,1032142,410681,796605,659925,692498,704701,128700,1014817,826473,35188,78953,915369,364066,1031106,114957,424066,39989,507466,531637,386833,574648,1002885,646344,720687,625500,743565,29508,663231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]