SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198430 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198430 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126547,995744,545863,190619,545287,142959,1022472,746341,1040365,264298,21041,990473,219073,541335,556946,803778,958874,984489,119316,572996,42092,59089,934318,588081,146512,944463,46013,65969,148202,401487,353403,5102,924062,256501,957673,260323,912919,348138,591393,550500,906290,902947,42244,441589,440748,100422,568377,776870,553161,155558,77067,29304,916101,399964,1011814,575512,159982,865640,595241,768830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]