SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027483 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027483 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047230,612412,292354,980249,190757,770620,18648,853572,180,11714,220354,437331,50809,1008013,995086,389554,111306,763196,539976,645169,859809,186142,253594,807997,1003178,376105,680792,828529,628109,164096,465645,192939,437136,539849,396939,733668,131900,183795,401212,889201,830905,538728,454890,849118,196128,95684,353890,880516,2217,484959,280473,440850,159372,63720,419480,308613,747573,28248,700028,380664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]