SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331584 LIMIT 1 [ RunTime:0.002080s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331584 [ RunTime:0.003890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326409,450014,656275,684944,385369,925433,292485,121535,137290,334915,349477,899582,434345,633400,238519,923959,878977,109282,617051,1002383,811944,224062,1037520,1037917,402019,731252,37710,848020,37500,977725,889936,929907,194035,1046113,236685,834058,464226,1009895,418369,337864,617990,25919,232792,207884,339748,497974,852620,361912,201255,449130,69275,729006,467001,1039401,115579,633647,787745,506181,608601,294814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]