SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453004 LIMIT 1 [ RunTime:0.001062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453004 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030541,665039,997492,372451,367382,478689,757203,817107,368619,957260,410132,354446,285857,770224,566671,547233,815078,35132,487020,68430,120649,336494,584859,832068,588292,41150,499886,291370,825197,811003,980500,836253,413415,707512,799167,55041,827428,98480,886506,315648,707676,871975,539326,764238,780755,920016,281762,153564,340645,593846,952486,519197,393271,808311,293994,966541,563487,708466,544011,852881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]