SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003400 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003400 [ RunTime:0.005668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455428,470511,277537,941463,992454,472923,988892,179544,600587,219454,472464,143126,141878,1005344,303387,853111,217438,632021,358635,8951,500634,886493,138535,765120,190608,181822,409644,725696,946435,1032312,76451,876470,544217,62554,333153,806268,332882,940512,614525,718536,208316,973913,434151,996815,134734,674476,263136,933394,141261,939992,556120,361763,349007,253040,412116,492190,727931,999591,200223,779025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]