SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465741 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465741 [ RunTime:0.003140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617613,341759,537355,87177,351016,608400,173049,830201,923367,838699,959792,401270,114173,611557,797720,664606,800160,981950,87145,684772,843673,334797,453223,819459,195662,769190,442333,51859,203027,115822,10536,513743,959864,474212,12463,275138,64370,902303,140476,877894,761631,874129,77747,873649,234586,879506,236969,479447,539020,942980,197507,844412,126117,717319,134867,1040237,911490,83044,398184,436757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]