SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201398 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201398 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512238,144955,382925,92409,411279,312469,508576,541162,327342,257227,784760,956433,375346,637028,697100,98354,161849,92298,722164,938272,50049,702923,521096,300507,367726,15565,950583,701137,134453,723758,43270,583379,508433,557143,861874,291705,680134,917740,209820,179038,462073,93716,534006,406805,360618,351078,945144,1006773,152166,1002649,311217,755129,755133,92774,972014,111984,448911,550872,998400,279414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]