SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339814 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339814 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535066,405644,497384,982509,412566,294305,652465,1048235,501975,857865,233944,879858,238767,798205,480137,535456,71016,282468,555868,117538,209021,90423,549356,90411,507130,59218,254136,645145,882470,912125,34159,6877,781359,718221,553187,754525,171535,600429,682316,275200,833287,912499,403527,85047,819493,705316,630421,75227,819079,109091,950066,920222,207518,745305,472352,229793,910411,626548,815092,45397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]