SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549961 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549961 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006139,166826,569249,286006,609344,483684,609830,936347,841154,21847,978244,614252,522514,182755,692955,1007381,89457,1030237,164491,866913,190502,521400,339930,364460,788997,387641,168117,727870,387814,544546,449641,1045463,710261,797787,522777,474588,472380,955077,711129,690540,490492,509398,30025,807530,739005,967950,405466,99658,136017,880731,766796,760272,753821,331101,805432,656549,1021581,132045,247530,986250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]