SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016827 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016827 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666856,999334,987764,433664,427169,187229,177094,389265,729882,815916,863895,444492,239058,246736,944537,263318,48086,641108,622388,391501,400607,602930,419067,470824,361712,411571,712234,700881,126699,61008,530448,794463,543764,71727,600815,468266,555302,548669,504634,662131,371476,509457,132921,325376,19161,566469,123796,475651,160021,616945,172283,762986,570746,820906,875592,660899,817842,429067,344821,297675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]