SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 913410 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 913410 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457462,804193,376327,326110,83171,666787,679642,265374,410196,668800,148089,734627,146458,712615,709215,453488,127453,28706,695669,168197,175139,620131,429456,668624,73541,799580,719726,692501,268687,737852,909009,247183,177672,270315,337255,97704,324126,452908,881020,179587,747624,188563,120672,810166,436641,305256,354197,30177,42044,471803,315196,89511,902976,672771,189652,424185,360858,476937,104044,93614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 913410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 913410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]