SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546092 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546092 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56444,1012571,126829,269345,74516,529651,351306,382560,160858,1044727,916889,999174,453546,704768,1016824,891027,435460,442094,611939,833241,373744,850987,948810,736027,465130,995134,155052,282701,722134,429586,136119,38021,825117,700918,714628,798973,501599,433095,317697,1018515,734035,193981,636601,600487,904835,249507,744723,751855,947380,642146,666017,956148,768018,787654,809720,229625,261626,4185,258151,734497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001130s ]