SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034991 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034991 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191520,478651,368584,556903,290139,52685,682954,633726,313843,1030075,1020070,964474,737216,255605,584645,681209,671151,991509,705057,913144,266295,720009,1033186,842080,199652,564122,714152,978069,706028,369906,604400,561956,430344,661783,358827,731048,211916,833713,52312,470561,112960,12051,670995,847686,86397,988314,165281,67089,599084,769202,752693,859464,385034,512964,673922,969952,959651,56534,301987,1001401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]