SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014187 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014187 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764559,372923,206783,657857,197811,738566,204230,714526,441326,972464,256341,309069,845076,50615,660571,190486,730669,830713,965805,551455,294374,231126,164591,331482,157210,962463,130606,126991,521053,261197,213833,118733,400661,75505,386612,388491,461254,390870,862376,452037,202940,70217,386799,939889,231355,518765,942938,359799,1047688,854151,429935,613542,87430,791186,703406,949979,751133,381426,366171,18662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]