SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022825 LIMIT 1 [ RunTime:0.000647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022825 [ RunTime:0.003941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570131,321808,301519,35451,834434,283028,250493,811367,675937,485095,905331,709949,1007641,151186,996908,130559,624634,6931,133763,940009,503969,989782,67737,602754,823179,378762,987062,515945,878005,519687,789972,231264,963169,766807,982286,552828,751423,500408,479069,306125,487844,289483,328951,768868,777643,957176,283708,354528,391,610896,418488,626853,168455,281550,973017,942415,827413,45875,487776,464067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]