SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544481 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544481 [ RunTime:0.003257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27227,321969,19978,569237,191098,582774,389183,1006991,425557,160481,538405,100024,591140,274374,770118,384376,531089,282019,923632,482302,659570,250047,934356,34551,800411,1019388,1036735,1037256,776115,850181,335929,873231,598368,246880,897554,381023,177454,286148,290403,312176,292362,906318,525180,551862,292105,288839,985280,192529,891650,357614,61370,241599,260243,462126,793882,660747,398572,482866,138572,14881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]