SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524832 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524832 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411937,715172,641325,491739,908720,589675,403653,1026750,322928,829920,642231,866542,800530,821374,61155,558453,474366,582194,267804,206027,786663,250450,985280,729475,98096,455053,724725,755684,687096,512719,515551,367196,188450,72010,179277,340013,937751,442308,736005,468232,82357,38984,347956,115418,497037,538318,417142,202440,364392,565145,550029,284825,413586,220280,440160,107257,206316,759456,575733,538023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]