SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412381 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412381 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503170,460172,201653,173058,1036495,967388,863745,251797,886336,34226,157793,167288,497660,327750,83265,368120,979015,1015591,113453,755539,146141,956520,304667,440651,959267,802485,848952,502532,155964,762008,742441,529858,917186,80708,576262,885661,929724,902274,678046,798897,180788,874088,677340,310789,490051,739214,755681,722555,818772,670122,302251,137537,225282,750382,677073,397003,337352,844353,812567,251275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]