SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102791 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102791 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631342,1007198,406014,17663,634049,128656,978952,740976,679255,483561,438165,205782,1041056,290259,2008,498079,980472,317435,222032,786707,9378,318178,162721,44063,140780,588175,565824,724454,869440,650967,73861,275112,644920,49908,288824,416060,420058,301636,655778,586257,348254,351681,194165,419069,733288,452410,523164,440595,1041650,83451,260309,18337,465243,852785,524912,49509,989907,416023,246923,934161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]