SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 903691 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 903691 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596361,336075,176336,369627,783360,998999,49552,5014,622218,197531,124981,285081,937858,229029,138300,444815,432573,608405,1001679,789191,6266,654495,455113,941683,782699,835879,876278,406028,423226,580292,766364,180705,503450,521266,310186,496392,839742,51087,981168,565196,431403,343311,923151,274386,192888,829555,937116,443871,181825,639621,279480,95831,128595,970167,614571,518099,685996,884416,329659,483519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 903691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 903691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]