SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19109 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19109 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481196,375306,521926,224390,18802,935106,1038567,122040,288842,874465,505168,589240,687490,419314,882672,59689,219391,911623,554200,79702,439067,511727,215603,796645,562018,509374,445364,690477,968321,543903,73004,69198,842594,348927,863984,19020,163966,429215,318120,756442,227839,219824,422870,682267,252185,336100,286913,116861,418384,1022338,711166,655686,214651,994896,984702,215206,244334,397792,864598,59215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]