SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525501 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525501 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519088,811905,512753,271229,209364,381283,822492,853823,408655,470365,61525,826087,148533,659921,667274,548653,63027,253218,604907,522822,624921,407736,749908,812952,347450,731294,746513,246697,1004610,124232,638753,10705,1022138,825059,63243,791031,237801,264733,867383,192257,956402,849925,812505,1024295,230900,283814,990260,1012860,700483,384911,520009,538958,961420,821132,828129,121594,629049,538667,803542,737209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]